microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 1

Which of the following is not true regarding Conditional Formatting?

a) You can add more than one condition to check

b) You can set condition to look for Bold and apply Italics on them.

c) You can apply Font, border and pattern formats that meets the specified conditions

d) You can delete any condition from Conditional Formatting dialog box if it is not required

e) None of these

Question : 2

In Excel when you see a cell with a red triangle in the top right corner, what does this signify?

a) There is an error in the cell

b) There is a comment associated with the cell

c) The font color for text in the cell is red

d) A formula cannot be entered into the cell

Question : 3

In Excel Documentation should include

a) Destination and users of the output data

b) Source of input data

c) Information on the purpose of the workbook

d) All of the above

Question : 4

Where can you change automatic or manual calculation mode in Excel?

a) Double CAL indicator on status bar

b) Go to Tools > > Options > > Calculation and mark the corresponding radio button

c) Both of above

d) Press F7

e) None of these

Question : 5

On an excel sheet the active cell In Indicated by...

a) A dark wide boarder

b) A dotted border

c) A blinking border

d) All of above

e) None of these